package LeetCode.interview;

import java.util.ArrayList;
import java.util.HashMap;
import java.util.LinkedList;
import java.util.List;
import java.util.Map;

import LeetCode.interview._104_Maximum_Depth_of_Binary_Tree.TreeNode;

import sun.tools.jar.resources.jar;
import util.LogUtils;

/*
 * 
原题　
		 Table: Person
	
	+-------------+---------+
	| Column Name | Type    |
	+-------------+---------+
	| PersonId    | int     |
	| FirstName   | varchar |
	| LastName    | varchar |
	+-------------+---------+
	PersonId is the primary key column for this table.
	
	Table: Address
	
	+-------------+---------+
	| Column Name | Type    |
	+-------------+---------+
	| AddressId   | int     |
	| PersonId    | int     |
	| City        | varchar |
	| State       | varchar |
	+-------------+---------+
	AddressId is the primary key column for this table.
	
	
	Write a SQL query for a report that provides the following information for each person in the Person table, regardless if there is an address for each of those people:
	
	FirstName, LastName, City, State
	

题目大意
	有两个数据表：Person表和Address表。Person（人员）表主键为PersonId，Address（地址）表主键是AddressId，通过PersonId与Person表关联。

	编写一个SQL查询，对于Person表中的每一个人，取出FirstName, LastName, City, State属性，无论其地址信息是否存在。
解题思路
	SELECT Person.FirstName, Person.LastName, Address.City, Address.State 
	FROM Person 
	LEFT JOIN Address 
	ON Person.PersonId = Address.PersonId;
 * @Date 2017-09-14 23：43
 */
public class _175_Combine_Two_Tables {


}
